﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$eComDBConnection$" formatter="bizobjlist of eComPaymentTerm">
	<Sql>
		SELECT
			eComCustomerPaymentTerms.paymentId as id, eComCustomerPaymentTerms.customerId as userId
		FROM
			Users 
		INNER JOIN
			eComCustomerPaymentTerms ON Users.id = eComCustomerPaymentTerms.customerId
		WHERE
			(Users.companyId = @companyId)
	</Sql>
	<Param name="companyId" type="UniqueIdentifier"/>
</AdoNetDataAccess>